SELECT *, CASE WHEN `name` LIKE "hampton bays%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hampton bays" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hampton bays" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hampton bays" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("hampton bays") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$5,699,00016 Penny LnHampton Bays NY 11946View Listing
$3,999,99916 Duckwood LnHampton Bays NY 11946View Listing
$3,495,00011 Bay View DrHampton Bays NY 11946View Listing
$3,150,00047 Romana DrHampton Bays NY 11946View Listing
$3,000,00041 Oak LnHampton Bays NY 11946View Listing
$2,999,0002 Peconic CresHampton Bays NY 11946View Listing
$2,900,00033A Newtown RdHampton Bays NY 11946View Listing
$2,795,00033 Mineola CtHampton Bays NY 11946View Listing
$2,500,0008A Old North HwyHampton Bays NY 11946View Listing
$2,449,00028 Canoe Place RdHampton Bays NY 11946View Listing
$2,395,00033 Newtown RdHampton Bays NY 11946View Listing
$2,250,00010 Canal WayHampton Bays NY 11946View Listing
$2,240,0008 Mill Pond RdHampton Bays NY 11946View Listing
$2,200,0004 Red Creek RdHampton Bays NY 11946View Listing
$2,149,99912 Red Creek CirHampton Bays NY 11946View Listing
$2,100,0006C Squires Pond RdHampton Bays NY 11946View Listing
$2,100,0009 Bay View Dr WHampton Bays NY 11946View Listing
$2,098,8887 Canoe Place RdHampton Bays NY 11946View Listing
$1,990,00095 Inlet Rd WHampton Bays NY 11946View Listing
$1,950,00027 Quail RunHampton Bays NY 11946View Listing
$1,875,00044 E Tiana RdHampton Bays NY 11946View Listing
$1,850,0003 N Shore RdHampton Bays NY 11946View Listing
$1,650,00014 E Landing RdHampton Bays NY 11946View Listing
$1,649,000104B Squiretown Rd Unit BHampton Bays NY 11946View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 6:07:58 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Ranch
Single Family
